The /moderate tool throws an internal server error while filtering by product

[emilghittasv]

Steps to reproduce
Steps to reproduce the behavior:

1. Go to https://support.mozilla.org/en-US/moderate
2. Choose a product from the Filter by product: dropdown
3. Navigate through the pagination items.

Expected behavior
The moderation tool is stable

Actual behavior
SUMO throws an internal server error or returns the filtered items quite slow.

Additional context
This issue is reproducible in prod

[smithellis]

mozilla/kitsune#6549

[emilghittasv]

@akatsoulas @smithellis

Yesterday I've created around 5k test data for the moderation tool (AAQ questions). The moderation tool was a bit slow when filtering by product and navigating through the pagination items but I couldn't cause an internal server error to occur.

I've bumped the test data to 10k and now I've hit the breaking point for stage meaning that I constantly hit the Internal Server Error (example: https://support.allizom.org/en-US/moderate?product=ios)

[akatsoulas]

PR mozilla/kitsune#6552

[emilghittasv]

@akatsoulas

Even with mozilla/kitsune#6552, unfortunately the ~10k test data is still too much for stage to handle.

[akatsoulas]

PR mozilla/kitsune#6554

[emilghittasv]

I can confirm that the moderation tool works nicely with ~10k test data now in stage.

I'm moving this ticket inside the release column.